Skip to main content

Connecting With Oracle Database

Connection Steps​

  1. Go to the Master data section and click on Data Source, as shown in the figure below:

    Docusaurus Slash Introduction

  2. Click on Create button from the bottom horizontal menu bar from Datasource section, as shown in the figure below:

    Docusaurus Slash Introduction

  3. The Create Datasource window will open, as shown in the figure below:

    Docusaurus Slash Introduction

  4. Search for oracle data source from Top-right search bar in Datasource section, as shown in the figure below:

    Docusaurus Slash Introduction

  5. Click on oracle to create a data source using oracle.

    Docusaurus Slash Introduction

  6. As you click on oracle, the create dialog box will pop-up on screen, as shown in the figure below:

    Docusaurus Slash Introduction

  1. Insert the following data in the Datasource connection Dialog box:-

  • Display Name: oracle [You can add name as per your requirements]

  • Class: oracle.jdbc.driver.OracleDriver

  • Connection URL: jdbc:oracle:thin:@localhost:1521:xe

  • Username: Admin [Insert your username]

  • Password: [Enter your respective oracle database password]

  • Verify added info, as shown in the figure below:

    Docusaurus Slash Introduction

  1. Click on Test Connection Button to Check Database Connection, after Connection Successful, it should look like the following figure:

    Docusaurus Slash Introduction

  2. Click on the ok and save button to close the Dialog box, The Created Successfully alert will pop-up on screen.

    Docusaurus Slash Introduction

    Now create a dataset after connecting the Datasource, click the link below:

Create dataset in OPNBI​